Show AllShow All

Create a macro for an ActiveX control

For more information about writing macros, see Microsoft Visual Basic Help.

  1. Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox.
  2. Click Design Mode Button image.
  3. Right-click the control, and then click View Code on the shortcut menu.
  4. In the Visual Basic Editor, write a new macro or change the existing macro.
  5. When you finish writing the macro, click Close and Return to Microsoft Excel on the File menu.
  6. When you finish designing the control, click Exit Design Mode Button image.

ShowTip